/*
CREATE TABLE "base_list" (
  "sequence_nbr" varchar PRIMARY KEY NOT NULL,
  "library_code" varchar,
  "library_name" varchar,
  "bd_code_level01" varchar,
  "bd_name_level01" varchar,
  "bd_code_level02" varchar,
  "bd_name_level02" varchar,
  "bd_code_level03" varchar,
  "bd_name_level03" varchar,
  "bd_code_level04" varchar,
  "bd_name_level04" varchar,
  "unit" varchar,
  "rec_user_code" varchar,
  "rec_status" varchar DEFAULT ('A'),
  "rec_date" varchar,
  "extend1" varchar,
  "extend2" varchar,
  "extend3" varchar,
  "zjcs_label_name" varchar,
  "zjcs_class_code" varchar,
  "zjcs_class_name" varchar,
  "description" varchar
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};
#[derive(Debug, Serialize, Deserialize)]
pub struct BaseList {
    pub sequence_nbr: String,
    pub library_code: Option<String>,
    pub library_name: Option<String>,
    pub bd_code_level01: Option<String>,
    pub bd_name_level01: Option<String>,
    pub bd_code_level02: Option<String>,
    pub bd_name_level02: Option<String>,
    pub bd_code_level03: Option<String>,
    pub bd_name_level03: Option<String>,
    pub bd_code_level04: Option<String>,
    pub bd_name_level04: Option<String>,
    pub unit: Option<String>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<String>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub zjcs_label_name: Option<String>,
    pub zjcs_class_code: Option<String>,
    pub zjcs_class_name: Option<String>,
    pub description: Option<String>,
}
crud!(BaseList {}, "base_list");
